﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace TinyCinema.Data
{
    public static class Tables
    {
        public static readonly string Promotion = "KHUYENMAI";
        public static readonly string Actor = "DIENVIEN";
        public static readonly string ScheduleType = "LOAISUATCHIEU";
        public static readonly string Genre = "THELOAIPHIM";
        public static readonly string ScheduleTypePrice = "DONGIASUATCHIEU";
        public static readonly string PromotionDetail = "CTKM";
        public static readonly string Acting = "DIENXUAT";
        public static readonly string OfGenre = "THUOCTLP";
        public static readonly string CustomerType = "LOAIKHACHHANG";
        public static readonly string Customer = "KHACHHANG";
        public static readonly string Movie = "PHIM";
        public static readonly string Schedule = "SUATCHIEU";
        public static readonly string Room = "PHONGCHIEU";
        public static readonly string BookedTicket = "PHIEUDATVE";
        public static readonly string TicketOrder = "HOADONVE";
        public static readonly string Ticket = "VE";
        public static readonly string MenuOrder = "HOADONTHUCDON";
        public static readonly string MenuOrderDetail = "CTHDTD";
        public static readonly string Menu = "THUCDON";
        public static readonly string Employee = "NHANVIEN";
        public static readonly string Position = "CHUCVU";
        public static readonly string Department = "PHONGBAN";
        public static readonly string Desk = "GHE";
        public static readonly string DeskType = "LOAIGHE";
        public static readonly string Country = "QUOCGIA";
        public static readonly string Feature = "CHUCNANG";
        public static readonly string Permission = "PHANQUYEN";
    }
    public static class Prefix
    {
        public static readonly string Promotion = "KM";
        public static readonly string Actor = "DV";
        public static readonly string ScheduleType = "LS";
        public static readonly string Genre = "TL";
        public static readonly string ScheduleTypePrice = "DG";
        public static readonly string PromotionDetail = "CK";
        public static readonly string Acting = "DX";
        public static readonly string OfGenre = "TT";
        public static readonly string CustomerType = "LK";
        public static readonly string Customer = "KH";
        public static readonly string Movie = "PH";
        public static readonly string Schedule = "SC";
        public static readonly string Room = "PC";
        public static readonly string BookedTicket = "PV";
        public static readonly string TicketOrder = "HV";
        public static readonly string Ticket = "VE";
        public static readonly string MenuOrder = "HD";
        public static readonly string MenuOrderDetail = "CH";
        public static readonly string Menu = "TD";
        public static readonly string Employee = "NV";
        public static readonly string Position = "CV";
        public static readonly string Department = "PB";
        public static readonly string Desk = "GH";
        public static readonly string DeskType = "LG";
        public static readonly string Country = "QG";
    } 
    public static class ActorTable
    {
        public static readonly string ID = "MaDV";
        public static readonly string Name = "TenDV";
    }
    public static class BookedTicketTable
    {
        public static readonly string ID = "MaPDV";
        public static readonly string CustomerID = "MaKH";
        public static readonly string Value = "TriGia";
        public static readonly string BookedDate = "NgayDatVe";
    }
    public static class CountryTable
    {
        public static readonly string ID = "MaQG";
        public static readonly string Name = "TenQG";
    }
    public static class CustomerTable
    {
        public static readonly string ID = "MaKH";
        public static readonly string CustomerTypeID = "MaLKH";
        public static readonly string Name = "TenKH";
        public static readonly string Gender = "GioiTinh";
        public static readonly string DateOfBirth = "NgaySinh";
        public static readonly string Address = "DiaChi";
        public static readonly string Phone = "DienThoai";
        public static readonly string Email = "Email";
        public static readonly string CardNo = "CMND";
        public static readonly string RegDate = "NgayDangKy";
        public static readonly string Password = "MatKhau";
        public static readonly string Point = "Diem";
    }
    public static class CustomerTypeTable
    {
        public static readonly string ID = "MaLKH";
        public static readonly string Name = "TenLKH";
        public static readonly string Picture = "HinhLKH";
        public static readonly string MinPoint = "DiemToiThieu";
        public static readonly string Discount = "HeSoUuDai";
    }
    public static class DepartmentTable
    {
        public static readonly string ID = "MaPB";
        public static readonly string Name = "TenPB";
    }
    public static class DeskTable
    {
        public static readonly string ID = "MaGhe";
        public static readonly string DeskTypeID = "MaLG";
        public static readonly string RoomID = "MaPC";
        public static readonly string Range = "Hang";
        public static readonly string Order = "ThuTu";
        public static readonly string IsUsed = "SuDung";
    }
    public static class DeskTypeTable
    {
        public static readonly string ID = "MaLG";
        public static readonly string Name = "TenLG";
        public static readonly string AdditionalPrice = "GiaCongThem";
    }
    public static class EmployeeTable
    {
        public static readonly string ID = "MaNV";
        public static readonly string PositionID = "MaCV";
        public static readonly string DepartmentID = "MaPB";
        public static readonly string ManagerID = "MaQL";
        public static readonly string Name = "TenNV";
        public static readonly string Gender = "GioiTinh";
        public static readonly string DateOfBirth = "NgaySinh";
        public static readonly string Hometown = "QueQuan";
        public static readonly string Address = "DiaChi";
        public static readonly string Phone = "DienThoai";
        public static readonly string CardNo = "CMND";
        public static readonly string StartDate = "NgayVaoLam";
        public static readonly string Password = "MatKhau";
        public static readonly string Photo = "HinhNV";
        public static readonly string Email = "Email";
    }
    public static class PromotionDetailTable
    {
        public static readonly string PromotionID = "MaKM";
        public static readonly string CustomerTypeID = "MaLKH";
        public static readonly string PromotionDiscount = "HeSoKM";
    }
    public static class MenuOrderDetailTable
    {
        public static readonly string MenuOrderID = "MaHDTD";
        public static readonly string MenuID = "MaTD";
        public static readonly string Quantum = "SoLuong";
    }
    public static class ActingTable
    {
        public static readonly string MovieID = "MaPhim";
        public static readonly string ActorID = "MaDV";
    }
    public static class SchedulePriceTable
    {
        public static readonly string ID = "MaDG";
        public static readonly string SchedulePriceTypeID = "MaLSC";
        public static readonly string StartTime = "GioBatDau";
        public static readonly string EndTime = "GioKetThuc";
        public static readonly string Day = "Thu";
        public static readonly string Price = "Gia";
    }
    public static class MenuOrderTable
    {
        public static readonly string ID = "MaHDTD";
        public static readonly string CustomerID = "MaKH";
        public static readonly string EmployeeID = "MaNV";
        public static readonly string OrderTime = "NgayHDTD";
        public static readonly string Value = "TriGia";
    }
    public static class TicketOrderTable
    {
        public static readonly string ID = "MaHDV";
        public static readonly string CustomerID = "MaKH";
        public static readonly string EmployeeID = "MaNV";
        public static readonly string Value = "TriGia";
        public static readonly string OrderDate = "NgayHDV";
    }
    public static class PromotionTable
    {
        public static readonly string ID = "MaKM";
        public static readonly string Name = "TenKM";
        public static readonly string Desciption = "NoiDung";
        public static readonly string StartDate = "NgayBatDau";
        public static readonly string EndDate = "NgayKetThuc";
        public static readonly string Photo = "HinhKM";
    }
    public static class ScheduleTypeTable
    {
        public static readonly string ID = "MaLSC";
        public static readonly string Name = "TenLSC";
    }
    public static class MovieTable
    {
        public static readonly string ID = "MaPhim";
        public static readonly string Name = "TenPhim";
        public static readonly string Poster = "Poster";
        public static readonly string Duration = "ThoiLuong";
        public static readonly string Director = "DaoDien";
        public static readonly string ReleaseYear = "NamPhatHanh";
        public static readonly string CountryID = "MaQG";
        public static readonly string Description = "NoiDung";
        public static readonly string ReleaseDate = "NgayKhoiChieu";
    }
    public static class RoomTable
    {
        public static readonly string ID = "MaPC";
        public static readonly string Name = "TenPC";
        public static readonly string DeskCount = "SoLuongGhe";
    }
    public static class ScheduleTable
    {
        public static readonly string ID = "MaSC";
        public static readonly string SchedulePriceID = "MaDG";
        public static readonly string RoomID = "MaPC";
        public static readonly string MovieID = "MaPhim";
        public static readonly string Time = "GioChieu";
        public static readonly string Day = "NgayChieu";
    }
    public static class GenreTable
    {
        public static readonly string ID = "MaTLP";
        public static readonly string Name = "TenTLP";
    }
    public static class MenuTable
    {
        public static readonly string ID = "MaTD";
        public static readonly string Name = "TenTD";
        public static readonly string Price = "DonGia";
        public static readonly string Photo = "HinhTD";
    }
    public static class TicketTable
    {
        public static readonly string ID = "MaVe";
        public static readonly string ScheduleID = "MaSC";
        public static readonly string DeskID = "MaGhe";
        public static readonly string BookedTicketID = "MaPDV";
        public static readonly string TicketOrder = "MaHDV";
        public static readonly string Price = "Gia";
    }
    public static class OfGenreTable
    {
        public static readonly string MovieID = "MaPhim";
        public static readonly string MovieTypeID = "MaTLP";
    }
    public static class PositionTable
    {
        public static string ID = "MaCV";
        public static string Name = "TenCV";
        public static string IsManager = "LaQuanLy";
    }
    public static class FeatureTable
    {
        public static string ID = "MaCN";
        public static string Name = "TenCN";
        public static string Description = "MoTa";
    }
    public static class PermissionTable
    {
        public static string FeatureID = "MaCN";
        public static string PositionID = "MaCV";
    }
}
